Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 10886 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.1 MiB |
| Average record size in memory | 104.0 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 5 |
datetime has a high cardinality: 10886 distinct values | High cardinality |
temp is highly correlated with atemp | High correlation |
atemp is highly correlated with temp | High correlation |
casual is highly correlated with count | High correlation |
registered is highly correlated with count | High correlation |
count is highly correlated with casual and 1 other fields | High correlation |
temp is highly correlated with atemp and 1 other fields | High correlation |
atemp is highly correlated with temp and 1 other fields | High correlation |
casual is highly correlated with temp and 3 other fields | High correlation |
registered is highly correlated with casual and 1 other fields | High correlation |
count is highly correlated with casual and 1 other fields | High correlation |
temp is highly correlated with atemp | High correlation |
atemp is highly correlated with temp | High correlation |
casual is highly correlated with registered and 1 other fields | High correlation |
registered is highly correlated with casual and 1 other fields | High correlation |
count is highly correlated with casual and 1 other fields | High correlation |
season is highly correlated with atemp and 2 other fields | High correlation |
count is highly correlated with casual and 1 other fields | High correlation |
casual is highly correlated with count and 3 other fields | High correlation |
atemp is highly correlated with season and 3 other fields | High correlation |
Unnamed: 0 is highly correlated with season and 2 other fields | High correlation |
temp is highly correlated with season and 3 other fields | High correlation |
registered is highly correlated with count and 1 other fields | High correlation |
Unnamed: 0 is uniformly distributed | Uniform |
datetime is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
datetime has unique values | Unique |
windspeed has 1313 (12.1%) zeros | Zeros |
casual has 986 (9.1%) zeros | Zeros |
Reproduction
| Analysis started | 2021-07-05 09:03:04.084590 |
|---|---|
| Analysis finished | 2021-07-05 09:03:11.775064 |
| Duration | 7.69 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
| Distinct | 10886 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5442.5 |
| Minimum | 0 |
|---|---|
| Maximum | 10885 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 85.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 544.25 |
| Q1 | 2721.25 |
| median | 5442.5 |
| Q3 | 8163.75 |
| 95-th percentile | 10340.75 |
| Maximum | 10885 |
| Range | 10885 |
| Interquartile range (IQR) | 5442.5 |
Descriptive statistics
| Standard deviation | 3142.661849 |
|---|---|
| Coefficient of variation (CV) | 0.5774298299 |
| Kurtosis | -1.2 |
| Mean | 5442.5 |
| Median Absolute Deviation (MAD) | 2721.5 |
| Skewness | 0 |
| Sum | 59247055 |
| Variance | 9876323.5 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2047 | 1 | < 0.1% |
| 3363 | 1 | < 0.1% |
| 7473 | 1 | < 0.1% |
| 5424 | 1 | < 0.1% |
| 9518 | 1 | < 0.1% |
| 3371 | 1 | < 0.1% |
| 1322 | 1 | < 0.1% |
| 7465 | 1 | < 0.1% |
| 5416 | 1 | < 0.1% |
| 9510 | 1 | < 0.1% |
| Other values (10876) | 10876 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 10885 | 1 | |
| 10884 | 1 | |
| 10883 | 1 | |
| 10882 | 1 | |
| 10881 | 1 | |
| 10880 | 1 | |
| 10879 | 1 | |
| 10878 | 1 | |
| 10877 | 1 | |
| 10876 | 1 |
| Distinct | 10886 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 85.2 KiB |
| 2012-06-15 11:00:00 | 1 |
|---|---|
| 2011-05-12 07:00:00 | 1 |
| 2011-08-19 13:00:00 | 1 |
| 2012-09-02 21:00:00 | 1 |
| 2011-04-19 06:00:00 | 1 |
| Other values (10881) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 206834 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 10886 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 2011-01-01 00:00:00 |
|---|---|
| 2nd row | 2011-01-01 01:00:00 |
| 3rd row | 2011-01-01 02:00:00 |
| 4th row | 2011-01-01 03:00:00 |
| 5th row | 2011-01-01 04:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2012-06-15 11:00:00 | 1 | < 0.1% |
| 2011-05-12 07:00:00 | 1 | < 0.1% |
| 2011-08-19 13:00:00 | 1 | < 0.1% |
| 2012-09-02 21:00:00 | 1 | < 0.1% |
| 2011-04-19 06:00:00 | 1 | < 0.1% |
| 2012-01-02 18:00:00 | 1 | < 0.1% |
| 2012-12-18 14:00:00 | 1 | < 0.1% |
| 2011-03-06 02:00:00 | 1 | < 0.1% |
| 2011-03-17 00:00:00 | 1 | < 0.1% |
| 2011-03-09 19:00:00 | 1 | < 0.1% |
| Other values (10876) | 10876 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 20:00:00 | 456 | 2.1% |
| 17:00:00 | 456 | 2.1% |
| 15:00:00 | 456 | 2.1% |
| 23:00:00 | 456 | 2.1% |
| 12:00:00 | 456 | 2.1% |
| 13:00:00 | 456 | 2.1% |
| 14:00:00 | 456 | 2.1% |
| 18:00:00 | 456 | 2.1% |
| 16:00:00 | 456 | 2.1% |
| 21:00:00 | 456 | 2.1% |
| Other values (470) | 17212 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 75100 | |
| 1 | 33624 | |
| 2 | 22493 | 10.9% |
| - | 21772 | 10.5% |
| : | 21772 | 10.5% |
| 10886 | 5.3% | |
| 3 | 3393 | 1.6% |
| 7 | 2972 | 1.4% |
| 5 | 2969 | 1.4% |
| 6 | 2969 | 1.4% |
| Other values (3) | 8884 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 152404 | |
| Dash Punctuation | 21772 | 10.5% |
| Other Punctuation | 21772 | 10.5% |
| Space Separator | 10886 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 75100 | |
| 1 | 33624 | |
| 2 | 22493 | 14.8% |
| 3 | 3393 | 2.2% |
| 7 | 2972 | 2.0% |
| 5 | 2969 | 1.9% |
| 6 | 2969 | 1.9% |
| 9 | 2969 | 1.9% |
| 8 | 2960 | 1.9% |
| 4 | 2955 | 1.9% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 21772 |
Space Separator
| Value | Count | Frequency (%) |
| 10886 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 21772 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 206834 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 75100 | |
| 1 | 33624 | |
| 2 | 22493 | 10.9% |
| - | 21772 | 10.5% |
| : | 21772 | 10.5% |
| 10886 | 5.3% | |
| 3 | 3393 | 1.6% |
| 7 | 2972 | 1.4% |
| 5 | 2969 | 1.4% |
| 6 | 2969 | 1.4% |
| Other values (3) | 8884 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 206834 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 75100 | |
| 1 | 33624 | |
| 2 | 22493 | 10.9% |
| - | 21772 | 10.5% |
| : | 21772 | 10.5% |
| 10886 | 5.3% | |
| 3 | 3393 | 1.6% |
| 7 | 2972 | 1.4% |
| 5 | 2969 | 1.4% |
| 6 | 2969 | 1.4% |
| Other values (3) | 8884 | 4.3% |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 85.2 KiB |
| 4 | |
|---|---|
| 2 | |
| 3 | |
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 10886 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 4 | 2734 | |
| 2 | 2733 | |
| 3 | 2733 | |
| 1 | 2686 |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| 4 | 2734 | |
| 3 | 2733 | |
| 2 | 2733 | |
| 1 | 2686 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 2734 | |
| 2 | 2733 | |
| 3 | 2733 | |
| 1 | 2686 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 10886 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 2734 | |
| 2 | 2733 | |
| 3 | 2733 | |
| 1 | 2686 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 10886 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 2734 | |
| 2 | 2733 | |
| 3 | 2733 | |
| 1 | 2686 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10886 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 2734 | |
| 2 | 2733 | |
| 3 | 2733 | |
| 1 | 2686 |
holiday
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 85.2 KiB |
| 0 | |
|---|---|
| 1 | 311 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 10886 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 10575 | |
| 1 | 311 | 2.9% |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| 0 | 10575 | |
| 1 | 311 | 2.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 10575 | |
| 1 | 311 | 2.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 10886 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 10575 | |
| 1 | 311 | 2.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 10886 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 10575 | |
| 1 | 311 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10886 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 10575 | |
| 1 | 311 | 2.9% |
workingday
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 85.2 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 10886 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 7412 | |
| 0 | 3474 |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| 1 | 7412 | |
| 0 | 3474 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 7412 | |
| 0 | 3474 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 10886 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 7412 | |
| 0 | 3474 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 10886 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 7412 | |
| 0 | 3474 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10886 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 7412 | |
| 0 | 3474 |
weather
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 85.2 KiB |
| 1 | |
|---|---|
| 2 | |
| 3 | |
| 4 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 10886 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 7192 | |
| 2 | 2834 | 26.0% |
| 3 | 859 | 7.9% |
| 4 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| 1 | 7192 | |
| 2 | 2834 | 26.0% |
| 3 | 859 | 7.9% |
| 4 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 7192 | |
| 2 | 2834 | 26.0% |
| 3 | 859 | 7.9% |
| 4 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 10886 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 7192 | |
| 2 | 2834 | 26.0% |
| 3 | 859 | 7.9% |
| 4 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 10886 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 7192 | |
| 2 | 2834 | 26.0% |
| 3 | 859 | 7.9% |
| 4 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10886 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 7192 | |
| 2 | 2834 | 26.0% |
| 3 | 859 | 7.9% |
| 4 | 1 | < 0.1% |
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.23085982 |
| Minimum | 0.82 |
|---|---|
| Maximum | 41 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 85.2 KiB |
Quantile statistics
| Minimum | 0.82 |
|---|---|
| 5-th percentile | 8.2 |
| Q1 | 13.94 |
| median | 20.5 |
| Q3 | 26.24 |
| 95-th percentile | 32.8 |
| Maximum | 41 |
| Range | 40.18 |
| Interquartile range (IQR) | 12.3 |
Descriptive statistics
| Standard deviation | 7.791589844 |
|---|---|
| Coefficient of variation (CV) | 0.3851338951 |
| Kurtosis | -0.9145302638 |
| Mean | 20.23085982 |
| Median Absolute Deviation (MAD) | 6.56 |
| Skewness | 0.003690844422 |
| Sum | 220233.14 |
| Variance | 60.7088723 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=49)
| Value | Count | Frequency (%) |
| 14.76 | 467 | 4.3% |
| 26.24 | 453 | 4.2% |
| 28.7 | 427 | 3.9% |
| 13.94 | 413 | 3.8% |
| 18.86 | 406 | 3.7% |
| 22.14 | 403 | 3.7% |
| 25.42 | 403 | 3.7% |
| 16.4 | 400 | 3.7% |
| 22.96 | 395 | 3.6% |
| 27.06 | 394 | 3.6% |
| Other values (39) | 6725 |
| Value | Count | Frequency (%) |
| 0.82 | 7 | 0.1% |
| 1.64 | 2 | < 0.1% |
| 2.46 | 5 | < 0.1% |
| 3.28 | 11 | 0.1% |
| 4.1 | 44 | 0.4% |
| 4.92 | 60 | 0.6% |
| 5.74 | 107 | |
| 6.56 | 146 | |
| 7.38 | 106 | |
| 8.2 | 229 |
| Value | Count | Frequency (%) |
| 41 | 1 | < 0.1% |
| 39.36 | 6 | 0.1% |
| 38.54 | 7 | 0.1% |
| 37.72 | 34 | 0.3% |
| 36.9 | 46 | 0.4% |
| 36.08 | 23 | 0.2% |
| 35.26 | 76 | 0.7% |
| 34.44 | 80 | 0.7% |
| 33.62 | 130 | |
| 32.8 | 202 |
| Distinct | 60 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.65508405 |
| Minimum | 0.76 |
|---|---|
| Maximum | 45.455 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 85.2 KiB |
Quantile statistics
| Minimum | 0.76 |
|---|---|
| 5-th percentile | 9.85 |
| Q1 | 16.665 |
| median | 24.24 |
| Q3 | 31.06 |
| 95-th percentile | 36.365 |
| Maximum | 45.455 |
| Range | 44.695 |
| Interquartile range (IQR) | 14.395 |
Descriptive statistics
| Standard deviation | 8.474600626 |
|---|---|
| Coefficient of variation (CV) | 0.3582570498 |
| Kurtosis | -0.8500756472 |
| Mean | 23.65508405 |
| Median Absolute Deviation (MAD) | 6.82 |
| Skewness | -0.1025595135 |
| Sum | 257509.245 |
| Variance | 71.81885578 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 31.06 | 671 | 6.2% |
| 25.76 | 423 | 3.9% |
| 22.725 | 406 | 3.7% |
| 20.455 | 400 | 3.7% |
| 26.515 | 395 | 3.6% |
| 16.665 | 381 | 3.5% |
| 25 | 365 | 3.4% |
| 33.335 | 364 | 3.3% |
| 21.21 | 356 | 3.3% |
| 30.305 | 350 | 3.2% |
| Other values (50) | 6775 |
| Value | Count | Frequency (%) |
| 0.76 | 2 | < 0.1% |
| 1.515 | 1 | < 0.1% |
| 2.275 | 7 | 0.1% |
| 3.03 | 7 | 0.1% |
| 3.79 | 16 | 0.1% |
| 4.545 | 11 | 0.1% |
| 5.305 | 25 | 0.2% |
| 6.06 | 73 | |
| 6.82 | 63 | |
| 7.575 | 75 |
| Value | Count | Frequency (%) |
| 45.455 | 1 | < 0.1% |
| 44.695 | 3 | < 0.1% |
| 43.94 | 7 | 0.1% |
| 43.18 | 7 | 0.1% |
| 42.425 | 24 | 0.2% |
| 41.665 | 23 | 0.2% |
| 40.91 | 39 | |
| 40.15 | 45 | |
| 39.395 | 67 | |
| 38.635 | 74 |
humidity
Real number (ℝ≥0)
| Distinct | 89 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 61.88645967 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 22 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 85.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 31 |
| Q1 | 47 |
| median | 62 |
| Q3 | 77 |
| 95-th percentile | 93 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 19.24503328 |
|---|---|
| Coefficient of variation (CV) | 0.3109732465 |
| Kurtosis | -0.7598175375 |
| Mean | 61.88645967 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | -0.08633518365 |
| Sum | 673696 |
| Variance | 370.3713058 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 88 | 368 | 3.4% |
| 94 | 324 | 3.0% |
| 83 | 316 | 2.9% |
| 87 | 289 | 2.7% |
| 70 | 259 | 2.4% |
| 65 | 253 | 2.3% |
| 46 | 247 | 2.3% |
| 66 | 246 | 2.3% |
| 77 | 244 | 2.2% |
| 49 | 234 | 2.1% |
| Other values (79) | 8106 |
| Value | Count | Frequency (%) |
| 0 | 22 | |
| 8 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 14 | 2 | < 0.1% |
| 15 | 4 | < 0.1% |
| 16 | 8 | 0.1% |
| 17 | 6 | 0.1% |
| 18 | 7 | 0.1% |
| Value | Count | Frequency (%) |
| 100 | 148 | |
| 97 | 1 | < 0.1% |
| 96 | 1 | < 0.1% |
| 94 | 324 | |
| 93 | 205 | |
| 92 | 2 | < 0.1% |
| 91 | 1 | < 0.1% |
| 90 | 4 | < 0.1% |
| 89 | 150 | |
| 88 | 368 |
| Distinct | 28 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.79939541 |
| Minimum | 0 |
|---|---|
| Maximum | 56.9969 |
| Zeros | 1313 |
| Zeros (%) | 12.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 85.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 7.0015 |
| median | 12.998 |
| Q3 | 16.9979 |
| 95-th percentile | 27.9993 |
| Maximum | 56.9969 |
| Range | 56.9969 |
| Interquartile range (IQR) | 9.9964 |
Descriptive statistics
| Standard deviation | 8.164537327 |
|---|---|
| Coefficient of variation (CV) | 0.6378846084 |
| Kurtosis | 0.6301328693 |
| Mean | 12.79939541 |
| Median Absolute Deviation (MAD) | 5.9965 |
| Skewness | 0.5887665266 |
| Sum | 139334.2184 |
| Variance | 66.65966976 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 0 | 1313 | |
| 8.9981 | 1120 | |
| 11.0014 | 1057 | |
| 12.998 | 1042 | |
| 7.0015 | 1034 | |
| 15.0013 | 961 | |
| 6.0032 | 872 | |
| 16.9979 | 824 | |
| 19.0012 | 676 | |
| 19.9995 | 492 | 4.5% |
| Other values (18) | 1495 |
| Value | Count | Frequency (%) |
| 0 | 1313 | |
| 6.0032 | 872 | |
| 7.0015 | 1034 | |
| 8.9981 | 1120 | |
| 11.0014 | 1057 | |
| 12.998 | 1042 | |
| 15.0013 | 961 | |
| 16.9979 | 824 | |
| 19.0012 | 676 | |
| 19.9995 | 492 | 4.5% |
| Value | Count | Frequency (%) |
| 56.9969 | 2 | < 0.1% |
| 51.9987 | 1 | < 0.1% |
| 50.0021 | 1 | < 0.1% |
| 47.9988 | 2 | < 0.1% |
| 46.0022 | 3 | < 0.1% |
| 43.9989 | 8 | 0.1% |
| 43.0006 | 12 | |
| 40.9973 | 11 | |
| 39.0007 | 27 | |
| 36.9974 | 22 |
| Distinct | 309 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.0219548 |
| Minimum | 0 |
|---|---|
| Maximum | 367 |
| Zeros | 986 |
| Zeros (%) | 9.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 85.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 4 |
| median | 17 |
| Q3 | 49 |
| 95-th percentile | 141 |
| Maximum | 367 |
| Range | 367 |
| Interquartile range (IQR) | 45 |
Descriptive statistics
| Standard deviation | 49.96047657 |
|---|---|
| Coefficient of variation (CV) | 1.38694518 |
| Kurtosis | 7.551629306 |
| Mean | 36.0219548 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | 2.495748398 |
| Sum | 392135 |
| Variance | 2496.049219 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 986 | 9.1% |
| 1 | 667 | 6.1% |
| 2 | 487 | 4.5% |
| 3 | 438 | 4.0% |
| 4 | 354 | 3.3% |
| 5 | 332 | 3.0% |
| 6 | 269 | 2.5% |
| 7 | 250 | 2.3% |
| 8 | 250 | 2.3% |
| 9 | 230 | 2.1% |
| Other values (299) | 6623 |
| Value | Count | Frequency (%) |
| 0 | 986 | |
| 1 | 667 | |
| 2 | 487 | |
| 3 | 438 | |
| 4 | 354 | 3.3% |
| 5 | 332 | 3.0% |
| 6 | 269 | 2.5% |
| 7 | 250 | 2.3% |
| 8 | 250 | 2.3% |
| 9 | 230 | 2.1% |
| Value | Count | Frequency (%) |
| 367 | 1 | |
| 362 | 1 | |
| 361 | 1 | |
| 357 | 1 | |
| 356 | 1 | |
| 355 | 1 | |
| 354 | 1 | |
| 352 | 1 | |
| 350 | 1 | |
| 332 | 1 |
| Distinct | 731 |
|---|---|
| Distinct (%) | 6.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 155.5521771 |
| Minimum | 0 |
|---|---|
| Maximum | 886 |
| Zeros | 15 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 85.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 36 |
| median | 118 |
| Q3 | 222 |
| 95-th percentile | 464 |
| Maximum | 886 |
| Range | 886 |
| Interquartile range (IQR) | 186 |
Descriptive statistics
| Standard deviation | 151.0390331 |
|---|---|
| Coefficient of variation (CV) | 0.9709863011 |
| Kurtosis | 2.626081 |
| Mean | 155.5521771 |
| Median Absolute Deviation (MAD) | 90 |
| Skewness | 1.524804587 |
| Sum | 1693341 |
| Variance | 22812.78951 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3 | 195 | 1.8% |
| 4 | 190 | 1.7% |
| 5 | 177 | 1.6% |
| 6 | 155 | 1.4% |
| 2 | 150 | 1.4% |
| 1 | 135 | 1.2% |
| 7 | 126 | 1.2% |
| 8 | 114 | 1.0% |
| 9 | 114 | 1.0% |
| 11 | 87 | 0.8% |
| Other values (721) | 9443 |
| Value | Count | Frequency (%) |
| 0 | 15 | 0.1% |
| 1 | 135 | |
| 2 | 150 | |
| 3 | 195 | |
| 4 | 190 | |
| 5 | 177 | |
| 6 | 155 | |
| 7 | 126 | |
| 8 | 114 | |
| 9 | 114 |
| Value | Count | Frequency (%) |
| 886 | 1 | |
| 857 | 2 | |
| 839 | 1 | |
| 833 | 1 | |
| 812 | 2 | |
| 811 | 1 | |
| 807 | 1 | |
| 806 | 1 | |
| 803 | 1 | |
| 802 | 1 |
| Distinct | 822 |
|---|---|
| Distinct (%) | 7.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 191.5741319 |
| Minimum | 1 |
|---|---|
| Maximum | 977 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 85.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 42 |
| median | 145 |
| Q3 | 284 |
| 95-th percentile | 563.75 |
| Maximum | 977 |
| Range | 976 |
| Interquartile range (IQR) | 242 |
Descriptive statistics
| Standard deviation | 181.1444538 |
|---|---|
| Coefficient of variation (CV) | 0.9455580042 |
| Kurtosis | 1.300092952 |
| Mean | 191.5741319 |
| Median Absolute Deviation (MAD) | 114 |
| Skewness | 1.242066212 |
| Sum | 2085476 |
| Variance | 32813.31315 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5 | 169 | 1.6% |
| 4 | 149 | 1.4% |
| 3 | 144 | 1.3% |
| 6 | 135 | 1.2% |
| 2 | 132 | 1.2% |
| 7 | 118 | 1.1% |
| 1 | 105 | 1.0% |
| 8 | 99 | 0.9% |
| 10 | 95 | 0.9% |
| 11 | 95 | 0.9% |
| Other values (812) | 9645 |
| Value | Count | Frequency (%) |
| 1 | 105 | |
| 2 | 132 | |
| 3 | 144 | |
| 4 | 149 | |
| 5 | 169 | |
| 6 | 135 | |
| 7 | 118 | |
| 8 | 99 | |
| 9 | 83 | |
| 10 | 95 |
| Value | Count | Frequency (%) |
| 977 | 1 | |
| 970 | 1 | |
| 968 | 1 | |
| 948 | 1 | |
| 943 | 1 | |
| 925 | 1 | |
| 917 | 1 | |
| 901 | 1 | |
| 900 | 1 | |
| 897 | 1 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| Unnamed: 0 | datetime | season | holiday | workingday | weather | temp | atemp | humidity | windspeed | casual | registered | count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 2011-01-01 00:00:00 | 1 | 0 | 0 | 1 | 9.84 | 14.395 | 81 | 0.0000 | 3 | 13 | 16 |
| 1 | 1 | 2011-01-01 01:00:00 | 1 | 0 | 0 | 1 | 9.02 | 13.635 | 80 | 0.0000 | 8 | 32 | 40 |
| 2 | 2 | 2011-01-01 02:00:00 | 1 | 0 | 0 | 1 | 9.02 | 13.635 | 80 | 0.0000 | 5 | 27 | 32 |
| 3 | 3 | 2011-01-01 03:00:00 | 1 | 0 | 0 | 1 | 9.84 | 14.395 | 75 | 0.0000 | 3 | 10 | 13 |
| 4 | 4 | 2011-01-01 04:00:00 | 1 | 0 | 0 | 1 | 9.84 | 14.395 | 75 | 0.0000 | 0 | 1 | 1 |
| 5 | 5 | 2011-01-01 05:00:00 | 1 | 0 | 0 | 2 | 9.84 | 12.880 | 75 | 6.0032 | 0 | 1 | 1 |
| 6 | 6 | 2011-01-01 06:00:00 | 1 | 0 | 0 | 1 | 9.02 | 13.635 | 80 | 0.0000 | 2 | 0 | 2 |
| 7 | 7 | 2011-01-01 07:00:00 | 1 | 0 | 0 | 1 | 8.20 | 12.880 | 86 | 0.0000 | 1 | 2 | 3 |
| 8 | 8 | 2011-01-01 08:00:00 | 1 | 0 | 0 | 1 | 9.84 | 14.395 | 75 | 0.0000 | 1 | 7 | 8 |
| 9 | 9 | 2011-01-01 09:00:00 | 1 | 0 | 0 | 1 | 13.12 | 17.425 | 76 | 0.0000 | 8 | 6 | 14 |
Last rows
| Unnamed: 0 | datetime | season | holiday | workingday | weather | temp | atemp | humidity | windspeed | casual | registered | count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10876 | 10876 | 2012-12-19 14:00:00 | 4 | 0 | 1 | 1 | 17.22 | 21.210 | 50 | 12.9980 | 33 | 185 | 218 |
| 10877 | 10877 | 2012-12-19 15:00:00 | 4 | 0 | 1 | 1 | 17.22 | 21.210 | 50 | 19.0012 | 28 | 209 | 237 |
| 10878 | 10878 | 2012-12-19 16:00:00 | 4 | 0 | 1 | 1 | 17.22 | 21.210 | 50 | 23.9994 | 37 | 297 | 334 |
| 10879 | 10879 | 2012-12-19 17:00:00 | 4 | 0 | 1 | 1 | 16.40 | 20.455 | 50 | 26.0027 | 26 | 536 | 562 |
| 10880 | 10880 | 2012-12-19 18:00:00 | 4 | 0 | 1 | 1 | 15.58 | 19.695 | 50 | 23.9994 | 23 | 546 | 569 |
| 10881 | 10881 | 2012-12-19 19:00:00 | 4 | 0 | 1 | 1 | 15.58 | 19.695 | 50 | 26.0027 | 7 | 329 | 336 |
| 10882 | 10882 | 2012-12-19 20:00:00 | 4 | 0 | 1 | 1 | 14.76 | 17.425 | 57 | 15.0013 | 10 | 231 | 241 |
| 10883 | 10883 | 2012-12-19 21:00:00 | 4 | 0 | 1 | 1 | 13.94 | 15.910 | 61 | 15.0013 | 4 | 164 | 168 |
| 10884 | 10884 | 2012-12-19 22:00:00 | 4 | 0 | 1 | 1 | 13.94 | 17.425 | 61 | 6.0032 | 12 | 117 | 129 |
| 10885 | 10885 | 2012-12-19 23:00:00 | 4 | 0 | 1 | 1 | 13.12 | 16.665 | 66 | 8.9981 | 4 | 84 | 88 |